Use BD_SYS_ATENCIONES
Go
Create Procedure dbo.GREstadoReq_Obtener(
   @iCodEstReq Int
)
As
Begin

   Select 
      iCodEstReq, 
      vNomEstReq,
      iCodUsu,
      vNomTer,
      dtFecAct
   From GREstadoReq a(Nolock)   
   Where iCodEstReq = @iCodEstReq
   
End